SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 587781 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 587781 [ RunTime:0.001729s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1030872,727265,992960,191669,19677,220094,979675,569314,979237,437023,564351,291921,1008677,108058,724252,582272,462085,404264,651449,564652,135455,678122,575477,415944,43529,91405,833198,832272,523659,99953,385187,997108,431190,282089,133658,438946,548936,130517,255237,810566,29029,213242,374898,856570,76192,1035596,787786,108467,264829,869778,17128,666215,283754,580684,508909,138151,685192,619757,383334,211581) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 587781 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 587781 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000642s ]