SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510079 LIMIT 1 [ RunTime:0.001348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510079 [ RunTime:0.002519s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (623497,396987,613177,103559,547739,866271,865938,846930,378862,616606,503428,437497,886318,504680,699,135821,890006,224759,565291,1042464,278890,544412,748768,44386,418804,946814,759137,264647,868237,919972,77099,449213,944319,988049,404078,118615,673651,573965,615737,511673,74388,477982,984293,747863,765274,710814,325177,578778,155296,816564,71382,218741,538060,260250,775079,954593,714489,810409,173690,912004) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005295s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510079 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510079 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001720s ]