SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 265401 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 265401 [ RunTime:0.001700s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (131443,425575,722745,274698,476010,535470,431290,95487,152983,936871,232857,1040071,801705,414991,321026,965807,289845,290793,567527,372416,599450,549032,32069,444468,645704,276782,90729,164263,362751,325409,783302,436417,611642,979925,39096,56971,327991,518803,973199,394186,1045558,959939,881231,420975,961519,842890,348716,160126,912901,1009417,266189,995825,424853,631381,575666,731604,313164,65822,599890,999465) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 265401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 265401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]