SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004818s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027111 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027111 [ RunTime:0.001493s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (235386,343479,465704,605815,865244,956652,262681,167251,500964,568790,391735,180588,551822,815989,778065,132604,809104,686308,791892,393763,74995,958723,409486,892020,815696,959350,700063,760048,549948,743718,819009,478404,901048,672712,614405,784090,46971,138285,412059,21074,1019280,484227,193833,356357,902780,927321,962507,462135,826972,92384,32929,496308,403263,372706,292934,810905,152399,314702,453768,1002736) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027111 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000545s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027111 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000438s ]