SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 192015 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 192015 [ RunTime:0.001690s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (242564,900609,77380,190528,613359,162132,259338,974100,355587,238164,726066,144365,284438,99859,48826,970182,833970,638843,622440,343135,822512,297415,217577,437981,606347,534075,1047741,510441,741594,414416,713717,581074,983457,56954,197788,484059,136363,351364,378450,200443,285095,481887,647657,70348,900100,787668,836772,705634,334124,126574,578024,387670,782758,296515,106649,999968,86559,543221,322284,1025404) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 192015 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 192015 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]