SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514529 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514529 [ RunTime:0.001681s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (319674,672848,557475,721953,998207,771220,586431,266876,731302,550914,481160,508456,528959,902366,256399,496603,462947,512744,414563,351052,696989,380956,865186,174018,443507,434010,349000,1007539,492527,255944,789562,223614,730315,606454,409548,911524,527418,794905,1032895,461236,913716,331659,640772,1034030,8392,483682,217501,821123,984582,809244,133930,35766,127354,1017231,510194,138477,1002349,535093,1009184,522393) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514529 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514529 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]