SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 568519 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 568519 [ RunTime:0.001619s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (258216,727667,692783,405932,462104,39675,298037,155459,966673,272070,717146,55482,241033,101537,304334,223130,90300,984873,899737,82240,812260,463597,58162,14321,568344,2464,749660,738717,24810,717223,713528,421675,282229,537504,430933,680108,1047547,163872,573536,1016127,867192,153178,966065,44088,164864,507646,260435,917446,256252,959906,992357,1018150,676417,266561,457668,201065,219006,584394,177251,216735) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 568519 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 568519 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000473s ]