SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 389221 LIMIT 1 [ RunTime:0.000511s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 389221 [ RunTime:0.003824s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (602042,970625,965649,135960,819184,91,261996,158587,920404,917373,493103,163639,666041,836516,21457,1037232,782992,220872,343300,387136,1046608,279612,22979,566511,660389,984669,699863,283122,185600,146935,685938,187449,786573,43400,665079,427349,647912,403199,225392,937166,10041,171603,42816,605843,480813,163737,628874,923460,834670,928294,991295,287048,182150,1022828,886872,532153,413554,820530,940218,592281) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 389221 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002216s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 389221 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]