SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 145158 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 145158 [ RunTime:0.001637s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (66474,109143,38923,805811,789579,613339,1002120,387702,1007556,203629,598091,141211,720581,195758,296573,398432,199854,29917,584622,26029,330169,84255,312531,747246,464384,752867,648580,1034383,223847,476504,618300,431500,283700,349489,139050,930325,233519,730071,153977,449840,939649,50429,186576,207801,159504,146678,863136,456823,803565,815812,120960,198289,594170,789771,701000,316018,736509,369014,778852,1033079) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001672s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 145158 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000616s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 145158 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001263s ]