SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 150541 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 150541 [ RunTime:0.002545s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (793121,470146,197852,386438,968294,934095,737095,1018247,785665,1045657,352712,799837,483474,492928,873846,374537,514540,404004,493202,1015458,800832,756207,69673,947582,115880,961854,396841,68475,46808,395003,1028711,375798,970795,841235,81774,844800,83564,298741,641488,717171,813406,826195,198678,945055,746505,120979,298654,569482,612135,424362,846062,10958,330728,253740,898279,772942,964419,588183,800436,455039) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 150541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002936s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 150541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000418s ]