SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 100781 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 100781 [ RunTime:0.001810s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (920366,846465,177932,1015240,672929,1022949,287894,905309,583720,784939,907805,533433,919432,341380,941707,108780,177998,151125,179912,831139,316956,471352,7362,661018,111783,776091,16452,86232,113727,828474,541992,120950,450334,4666,624854,966171,189868,519320,613108,824902,470253,192283,355342,252343,195658,24872,733351,866417,296713,966936,225476,547523,237395,763410,671771,41977,44084,361847,982842,576096) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 100781 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 100781 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000382s ]