SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001424s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1025230 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1025230 [ RunTime:0.001565s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (947073,355016,147266,423075,426902,1023037,926789,596676,63893,393992,708480,196459,504347,371161,924800,349592,844468,685419,767576,1017851,1003671,160150,36178,805026,316671,90114,1030833,196206,557517,519526,946579,530719,530154,851043,938153,405778,208401,825061,762337,701110,299605,642901,133145,579441,656447,3278,834281,697569,246031,133451,675866,94457,488710,965324,239347,273338,745851,322596,967474,985764) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1025230 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1025230 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]