SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507839 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507839 [ RunTime:0.001681s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (594470,540005,685179,498019,517474,745063,518432,670328,64264,4645,648661,845330,481412,885221,64706,139858,929648,91752,232017,112233,1020347,234046,417898,40608,543263,106559,732645,187576,675929,918227,621118,402995,954109,875184,1025577,945749,361666,863338,407094,769352,433105,688074,183154,41967,676976,357718,388969,1020208,422358,591775,375592,1010328,710314,709431,135439,915618,230307,16746,477751,396743) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008648s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507839 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000511s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507839 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001351s ]