SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.006813s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 392840 LIMIT 1 [ RunTime:0.002307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 392840 [ RunTime:0.001433s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (210880,2382,250655,156502,524269,575766,616934,156901,167834,729498,516584,156091,804844,983412,453440,431080,138065,832140,104595,199737,832330,807347,392724,410059,298817,1002746,827971,94711,869746,214074,677332,451608,721119,201832,1036396,1012786,133203,696751,547875,951520,814583,874990,274599,659778,642391,395667,852599,1467,355198,710474,293064,880015,313623,20243,983134,226059,140930,539678,431955,1018561) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.013989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 392840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 392840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001687s ]