SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416108 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416108 [ RunTime:0.002104s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (395183,487597,407172,225681,19395,804578,82390,678233,722700,286169,893614,15504,985909,47013,564711,623080,726610,403765,874107,221107,95175,905946,482245,702982,160231,757046,1014648,648355,134086,573603,99467,755464,1000412,111782,294042,915316,337343,984115,741621,57521,232337,75536,480048,969314,745796,331241,375986,669447,968007,48890,887480,308286,712716,584141,6768,511217,212856,626903,72944,74500) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416108 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416108 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]