SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002694s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200103 LIMIT 1 [ RunTime:0.000453s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200103 [ RunTime:0.001753s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (308659,489746,345230,849169,826337,813714,554029,1023103,527478,491720,776496,469330,546172,591634,491776,677828,518871,869109,368798,608332,491224,366496,935093,828803,936387,43582,86498,285649,6194,826727,716275,552506,217428,885305,91044,345070,741706,515015,88307,66811,66356,573699,248599,652336,845382,514314,654754,905212,474700,630099,933937,52090,927175,259536,998942,3825,160365,139460,450325,1026940) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001590s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000678s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000442s ]