SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001605s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429035 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429035 [ RunTime:0.001825s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (563637,500702,340802,22523,472620,105731,969190,647178,742511,1039004,259998,1009624,474246,707316,604082,916668,268255,801723,567641,1028520,542355,246859,385318,487415,511265,637034,847921,805894,564877,14226,574142,98832,700255,139810,497334,469553,955390,919625,585381,450679,254315,77400,836256,63855,6934,95957,664754,73211,361311,835050,796447,113846,513067,188079,139662,317679,1037842,455868,445393,480341) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429035 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429035 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]