SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001710s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195080 LIMIT 1 [ RunTime:0.001275s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195080 [ RunTime:0.003141s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (249388,870143,379899,988563,208612,907217,432279,518984,990553,420748,738253,299164,754297,535042,96089,471458,561834,79376,820426,270329,306928,83037,69416,720743,817023,213564,825865,458311,698077,376861,512341,289738,1034784,726696,378127,1006048,360436,855045,160532,369891,752544,874802,398930,11195,773801,363847,779712,700711,535210,975632,396048,506892,564944,603779,813955,570453,301318,313596,560111,891080) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002239s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001365s ]