SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407241 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407241 [ RunTime:0.001813s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (623668,874769,366215,1036456,873391,363590,258757,169239,450596,606945,1011690,906318,774697,1025489,40174,629716,986460,278916,537031,522283,539657,919780,833256,185280,663495,807021,320245,294707,584093,212397,703288,6814,8933,846388,115154,744592,710463,920802,150376,288100,54943,88626,1004441,969307,117648,6836,747995,413265,37170,199860,299748,612407,98971,907278,2796,538215,220859,634342,507630,366725) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407241 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407241 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]