SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450575 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450575 [ RunTime:0.004054s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1018187,1008095,432134,823504,319999,845776,984240,18438,177089,316645,853184,100243,31034,244252,531599,426412,37237,843305,994106,104215,507201,38943,115677,328441,492440,580401,540096,230350,139137,667909,663739,748024,911487,1002688,220945,118843,300514,808979,149408,348323,121183,574296,888500,757114,918748,425705,55758,129958,817174,304270,1009648,407536,893428,240012,6803,78288,553163,809829,405390,54569) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450575 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450575 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]