SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001349s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512580 LIMIT 1 [ RunTime:0.000437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512580 [ RunTime:0.002032s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (366196,243061,798552,471073,780490,552206,15924,560942,826942,749569,564668,246835,930101,183240,567498,98581,771573,781145,970549,151108,616965,750274,368950,487686,718714,742981,898967,101431,522932,1031665,629488,948434,404740,194681,388658,90045,172730,206639,686713,466568,257284,680632,331472,651384,350463,259310,678823,99400,206162,92948,408054,851973,392655,830871,998348,375438,690403,102933,425726,202446) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000667s ]