SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002300s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 806581 LIMIT 1 [ RunTime:0.000905s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 806581 [ RunTime:0.001612s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (473522,550581,831690,393322,372925,179594,271812,106396,508523,945243,166432,51270,374858,349561,972006,432454,19468,334860,102601,613919,953029,805346,489293,1013858,618479,425859,958861,939560,134060,672428,872879,144603,702183,670965,135646,884609,332595,216915,74964,389912,997491,287631,314079,948820,708394,277651,722552,285253,172403,847740,296850,486103,724840,272523,1003698,44512,665633,37925,564288,805370) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 806581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 806581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000399s ]