SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 390875 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 390875 [ RunTime:0.001907s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (102220,890023,556407,487993,618259,131015,276816,387898,641878,21913,923579,222689,352096,201077,311596,110327,171576,160608,91731,807980,548460,413152,730345,637439,383614,973623,958579,751046,386075,616550,343748,660003,836618,142115,830749,442944,405652,1040931,253545,309900,438901,78,86080,674558,892663,192653,749775,344552,148460,4240,182379,447943,399254,712675,516130,234741,477309,897706,760457,622068) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 390875 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 390875 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002232s ]