SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001972s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506810 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506810 [ RunTime:0.001583s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (273547,234437,840179,277746,543060,889362,687639,283439,369165,29415,42197,1014223,509024,738532,895429,472359,324779,58587,850783,966521,755820,439540,779262,956146,366738,403860,442246,919052,487249,405742,323038,677013,989484,224450,278740,941430,404667,359839,746244,180670,247089,94843,256500,183404,312684,978278,930417,620314,760100,655889,983974,356961,426427,252481,856933,23305,702493,824319,914621,656084) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000516s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]