SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 254543 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 254543 [ RunTime:0.002408s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (311180,3594,885397,733993,63132,714270,487095,833915,715319,725234,102311,707802,974501,454965,518731,873222,137132,195479,904078,724236,50208,1001368,349302,278046,850654,660649,1003578,980388,416053,971470,225210,695000,715472,861100,808025,247414,640532,219162,501022,897194,1016053,296994,856967,8469,609172,192655,465697,946882,253196,565167,915752,518798,746543,378982,559273,1012062,180088,305171,10448,540133) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 254543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 254543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]