SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503686 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503686 [ RunTime:0.001958s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (809728,972426,259584,840754,1006019,673255,125970,180314,181875,61290,612267,444485,238964,54679,491599,1015786,40879,522482,65936,378006,407110,377843,49045,708158,222387,469941,936689,31640,1023221,692914,119470,626872,16167,69030,960892,302590,209338,577637,973355,1027551,560706,86192,664942,742014,285194,283661,909190,889646,807192,1022838,1032860,325528,1033107,282162,1038460,794240,801153,676616,363856,349111) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503686 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503686 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]