SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 383261 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 383261 [ RunTime:0.001680s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (790484,668406,86989,808030,94709,970762,31413,661145,567413,969736,238075,170070,335261,180558,987795,194532,919440,440359,153923,409787,148080,823898,1036552,726145,933397,468096,516834,532479,918244,1030869,274740,95551,960049,139753,142547,861124,1038408,1017341,406782,1011624,842553,834638,593633,79771,662206,1019826,1010935,716640,71764,957572,461970,355046,286147,342907,419511,522018,772784,654391,707975,541654) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 383261 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 383261 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]