SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409650 LIMIT 1 [ RunTime:0.000500s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409650 [ RunTime:0.004114s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (154492,155390,328475,41857,262810,754081,712732,399102,835997,380914,452302,1005299,954234,234113,566257,492315,52433,789427,593734,968084,30499,963696,327503,326626,29470,628938,949790,853160,1009751,650610,285176,163582,849254,118570,33010,225818,67784,837032,317819,432714,671660,627434,1036279,780703,958381,353587,581357,359046,218191,282446,365040,631262,555288,207762,701483,7831,378580,108782,715153,37074) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004307s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409650 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000508s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409650 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]