SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 141718 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 141718 [ RunTime:0.001660s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (161194,292188,225955,190638,872764,774141,535984,469212,759923,1040279,199842,719859,742948,734372,344564,389196,271627,393038,556501,742308,1029055,548569,953276,811751,855202,513664,850775,831490,850982,699667,746423,69506,150364,516235,258080,824925,288917,612872,234973,379629,588447,781881,158706,1018563,280833,214259,778822,355521,680893,677496,132680,1005544,391660,641963,716712,65210,414658,106020,419688,23972) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 141718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 141718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000422s ]