SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002020s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002651 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002651 [ RunTime:0.001669s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (711186,800143,197465,527633,609609,1020021,108046,849199,950459,358613,512586,159208,1027332,208750,820168,77491,914495,757938,353616,353789,500325,438252,527713,117090,502915,713658,15476,898501,189659,756479,133790,337627,879285,531167,618979,941506,9100,131536,195130,635243,684940,297797,140723,394051,899293,904539,844994,376265,759715,111672,384640,107561,330127,133885,469756,245111,511536,965400,959593,522094) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002651 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000589s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002651 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001691s ]