SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001855s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 48701 LIMIT 1 [ RunTime:0.000491s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 48701 [ RunTime:0.002018s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (20336,463973,996316,894677,827923,101976,811513,194234,1003130,745159,49282,49890,217725,218504,1003932,223173,416651,788252,931031,671961,539213,452343,927900,138195,306342,952355,462162,167415,249205,1037612,606333,873695,489020,612600,203408,559214,108159,756415,823611,488755,620024,367374,272405,707138,536240,665112,403506,951586,198173,129182,820443,606464,673883,525381,952289,488547,509813,766599,188085,835650) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 48701 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000666s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 48701 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]