SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003544s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 332004 LIMIT 1 [ RunTime:0.002585s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 332004 [ RunTime:0.011374s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (529863,366053,447117,669366,400246,1034340,585647,226312,867235,748439,1007263,154265,688553,684771,563373,932922,542288,25121,104405,500864,845608,441496,399407,618211,966628,103437,760348,970492,2320,798371,854093,221428,484316,516855,709971,482221,731141,666784,749206,446642,312295,30796,66689,867069,348640,853028,346129,656334,251446,604164,549189,617492,441290,919987,308100,534300,456667,543409,98338,914942) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 332004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000555s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 332004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002475s ]