SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000953s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520493 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520493 [ RunTime:0.001613s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (479969,120295,76200,852152,132095,520031,272606,821656,319542,638370,117505,613512,457982,525447,332843,39872,926707,64930,965673,805312,12548,700263,418425,302932,84514,665932,75402,524998,730543,128176,198160,403690,255134,892872,562578,594943,138893,767141,540687,125171,889067,346739,646390,122205,566621,549515,298828,354872,615007,923271,798720,506378,462553,78103,526086,728213,998869,346070,821407,888380) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520493 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520493 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000813s ]