SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 386753 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 386753 [ RunTime:0.001728s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (239304,1020141,1027362,867651,836550,385744,664003,336503,105097,950417,782995,698620,987991,39947,262418,623447,98009,668852,11742,249009,628846,386375,892959,506028,577755,487452,507987,332310,289313,400444,407269,125139,315922,203308,404092,407329,404216,397689,789406,952738,548119,764861,901589,853139,912382,895746,317163,772865,325723,364628,314688,549070,1014260,75773,380595,18985,471087,879770,897660,762401) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 386753 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 386753 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000433s ]