SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400143 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400143 [ RunTime:0.002260s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (561801,367597,360679,11873,713602,632541,446594,940054,680360,55845,12196,972930,61375,88259,115254,8272,831659,203839,378062,53706,182176,483420,442820,1006673,116171,818221,19162,814273,740299,630040,297092,417654,497377,177097,461112,848424,688978,719088,542447,239081,826212,657065,282313,190844,458167,672127,674255,835876,428254,645334,999171,741887,926131,507009,196581,895544,633831,971139,104935,200949) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400143 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400143 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]