SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 144098 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 144098 [ RunTime:0.002350s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (705936,158036,71504,642221,256292,755093,911722,567038,252560,962210,401472,427042,923884,1048003,397875,604693,686346,481710,644068,245318,7657,1047169,53087,657915,224390,517882,844649,608173,441685,487453,895945,795257,12539,336590,179978,597370,236539,499986,970995,22387,336748,932238,910772,776690,316887,180674,1012390,890205,118997,790302,1004277,780798,789153,482722,176105,26950,677754,125692,575032,1027750) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000924s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 144098 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 144098 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]