SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480968 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480968 [ RunTime:0.001820s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1001904,430649,366596,243353,758930,880390,433428,396288,677036,519733,808583,28746,774822,351887,176704,338964,966639,1208,216679,977507,877288,807196,537973,457879,534243,53237,859516,62387,268181,378302,926464,389516,473522,456420,664982,310012,190177,563723,469987,58556,257650,697802,210705,266938,525365,589070,92992,526700,97272,815453,948301,954124,318432,1012760,197677,658525,79666,948292,349247,75353) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480968 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480968 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]