SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 43546 LIMIT 1 [ RunTime:0.003709s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 43546 [ RunTime:0.003667s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (50498,316196,342806,343206,985474,930508,601493,288134,704401,250028,369370,538986,428543,432689,887620,115903,243219,101813,782042,316703,609871,462970,619792,1006909,977555,4029,664487,529712,1019188,738632,652765,931357,989140,847418,1021094,741905,702919,301024,200688,738397,784776,836600,445081,548143,429220,47074,444176,651673,995944,942802,660222,544883,405624,455385,212323,739634,299985,159534,146943,1046948) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 43546 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004245s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 43546 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001637s ]