SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019247 LIMIT 1 [ RunTime:0.000530s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019247 [ RunTime:0.002837s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (770760,445090,169614,889246,230510,124623,18197,336066,574946,910791,749879,424413,127537,770709,955661,147844,1012865,599990,982649,894346,1023660,197387,504122,1013063,807817,243152,87557,134879,126110,985857,321326,242830,732671,1172,897837,564254,828240,874904,557305,394101,1035911,282712,175791,619166,774236,434307,991189,38430,886374,409021,11166,961084,536922,599022,1124,232973,657667,277286,765116,921212) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019247 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000508s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019247 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]