SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047452 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047452 [ RunTime:0.001588s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (911266,998864,514763,563927,574622,18524,368402,1035354,477277,408843,728899,262387,22903,883062,468603,606286,545395,575657,936814,61420,417194,956042,469042,709436,652906,447970,987412,589082,121600,1023581,564283,575610,928681,724426,147313,581724,776087,982297,456736,265317,26808,746333,583482,809650,792214,1021555,308955,781722,621555,750347,228808,836047,480741,977241,990938,669933,183161,425714,97026,936865) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047452 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047452 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000753s ]