SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519591 LIMIT 1 [ RunTime:0.001233s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519591 [ RunTime:0.001862s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (978582,263948,35713,59207,555815,114123,568677,747878,908989,701789,908831,865821,53217,995115,651822,965241,705183,797872,376890,129426,92544,620312,670467,615623,1001835,699497,534730,1037093,871176,1013682,528973,807280,765028,906860,699582,700135,263507,348500,187920,589644,844887,1000662,655731,14311,619863,983330,851179,675353,991323,94143,621682,701645,971522,175843,111958,540369,467616,536728,1018836,854654) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000971s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519591 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519591 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000438s ]