SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 465876 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 465876 [ RunTime:0.003440s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (710380,686491,761701,1032285,378740,108173,428246,932322,1004751,38301,496887,893765,180758,59327,950008,137229,120641,554397,639555,231738,1002320,120339,829650,842783,324313,296740,92624,926529,399708,930930,738479,817151,642164,861331,588868,269549,558526,987344,209947,347039,62011,711800,426639,923433,524149,745929,649129,954135,716864,617527,495913,909466,813328,368569,381342,893947,386263,897767,917004,220532) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 465876 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 465876 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]