SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003585s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 682306 LIMIT 1 [ RunTime:0.004446s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 682306 [ RunTime:0.002976s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (540201,48205,61713,948233,237818,42522,870269,1037763,329893,345638,289735,402600,722889,718086,129380,353968,739654,218362,1035438,695271,719304,772757,59149,885796,469051,796704,87561,643889,332168,353777,713528,933402,453897,552838,518027,28112,556492,612421,950174,827789,934441,263104,409083,976799,378504,189544,591591,760311,128306,235315,204882,197310,948430,835376,484086,279108,132031,512593,689515,468510) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005661s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 682306 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 682306 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]