SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001357s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409234 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409234 [ RunTime:0.006702s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (460841,161666,1010661,143263,936593,564954,97747,444166,421384,314138,664404,420740,458856,705007,984042,122367,176330,569134,924773,104374,704558,204124,615569,33386,681855,173328,313970,357904,625844,957149,517433,214025,911335,363843,720960,633361,967216,458709,325051,256082,99693,882962,767694,812046,659314,915306,621154,223552,162090,523807,134504,110758,673262,699354,735385,531979,251001,712610,486408,792610) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409234 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003946s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409234 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000483s ]