SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409482 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409482 [ RunTime:0.002192s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (382037,57074,94263,209462,871642,664331,801,359436,946200,149966,725414,398524,416510,748138,228264,134508,292476,340871,331472,498583,765265,1042413,1044585,153081,795821,984859,235643,288041,386281,488812,703927,120311,742909,364824,774077,595293,542399,22915,436190,87046,619168,503298,496640,282733,856305,450554,863429,250382,208447,394590,251108,429149,386531,949080,196495,407587,970667,706287,103289,247943) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409482 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409482 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]