SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417399 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417399 [ RunTime:0.001585s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (41882,390034,525642,590171,694065,849808,998947,113355,938802,10179,500274,452186,973380,787269,839283,583323,449588,798167,164516,48289,830469,64880,163303,895221,401277,625791,952826,218832,480443,286212,575343,686576,472767,957654,523164,695371,642693,579736,453193,294637,420783,67591,214180,229350,693650,16656,359721,138755,195447,369918,382677,56074,225127,158458,702632,264616,400831,475484,898451,426045) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417399 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417399 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]