SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012243 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012243 [ RunTime:0.001703s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (615506,873450,209204,41418,916373,858189,705735,559297,900429,584445,955262,413267,814231,278068,857783,213944,525427,191244,981291,1002637,921560,1029563,841688,399321,26975,176254,520106,373402,33113,458604,487850,977800,279385,387289,840071,253910,30159,794482,154304,349552,699395,993568,669673,333949,753999,552993,599925,235469,815023,335026,1032585,565459,1027899,87818,202985,205458,270477,92023,987876,235619) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001562s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000656s ]