SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042656 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042656 [ RunTime:0.005670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (163797,421365,401362,1026451,799561,312937,455854,559517,715399,984378,179564,628397,435551,287512,94034,135652,679901,248493,1021583,767705,614655,101510,269330,20146,418550,323778,161603,718606,755936,985505,264461,682401,316947,1037506,990639,127293,173408,1006359,34987,275428,426940,3528,988527,867097,789505,1030520,495737,658095,74813,1043137,39739,546832,599141,358292,256770,307753,434118,610324,471870,821362) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042656 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042656 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000854s ]