SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514870 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514870 [ RunTime:0.003224s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (147315,131421,180778,103427,685121,349282,625999,138109,384052,906502,871758,432354,523632,257943,515839,894008,200531,967348,407907,602853,581612,355470,874397,286884,691244,1010107,85076,441673,259611,481101,955196,530372,591550,115553,1011876,815921,726435,945839,249510,1002709,687446,38656,19982,680010,954142,791875,108356,397769,1024103,590476,591371,600932,688371,727040,133388,419400,1045443,575980,991506,181456) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514870 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514870 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]