SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 566531 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 566531 [ RunTime:0.001584s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (164825,236126,896776,392619,706101,190512,143911,688431,1029498,53095,439860,988096,618362,390697,931549,97183,45118,392137,246479,475293,467705,108029,245869,31500,490089,123656,922057,656655,379920,110650,531021,1026143,413862,806057,908046,519022,623996,273467,109112,849823,360095,5395,198473,635518,774465,864103,416747,997405,181214,36504,86954,434385,874211,253740,175811,71709,569210,335001,361995,849805) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000953s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 566531 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 566531 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000434s ]