SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 382246 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 382246 [ RunTime:0.002005s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (783759,1036883,113614,673683,849358,62064,527934,814544,87554,572821,949685,197181,554774,206388,856172,412610,224425,711942,61430,36972,70605,18853,545313,195673,187342,482178,423429,260561,1017110,15018,931828,914692,809896,340853,313323,936098,982545,884153,755357,912009,325882,168262,434566,209871,687664,956258,767469,442690,143240,329728,837987,799759,677290,368800,651021,795283,1009580,141677,994326,366729) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000957s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 382246 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 382246 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]