SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 345711 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 345711 [ RunTime:0.001552s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (196387,785794,951389,814570,558318,372223,318811,208623,526408,518673,231877,751590,32842,244999,881414,747576,16745,141903,472920,1035396,1046662,233594,854282,854710,680809,425237,640231,11327,554080,526961,213941,669974,363321,410915,882671,1015816,727846,86572,917939,838801,85578,530004,687941,910288,31829,617238,956089,149067,442227,198559,554024,621476,56866,34303,213257,1048484,217960,726840,564525,570258) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000939s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 345711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 345711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000442s ]