SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 33654 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 33654 [ RunTime:0.001829s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1012847,556773,255493,783359,113344,259106,401232,219472,906180,120563,651165,281473,192393,270196,740197,178754,332984,19356,242695,148244,683129,382022,468690,872749,313863,496928,566898,684453,28875,973798,58810,415496,260955,550745,662909,250849,375042,548150,604564,890320,71133,605894,916996,186984,300589,709553,456365,844305,100959,37725,181113,234272,842886,85284,874808,834658,700767,516117,138205,123233) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 33654 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 33654 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]