SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001434s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 342057 LIMIT 1 [ RunTime:0.000476s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 342057 [ RunTime:0.001981s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (654022,949597,1017262,450480,339903,197652,443814,801764,969745,553580,426338,1000604,221577,831208,541556,887536,554515,157153,307273,39962,997236,412823,1028471,646201,80602,770407,788669,1992,221931,119033,431835,101163,767691,377605,159530,113010,382646,57358,36527,488169,236464,754813,660022,687850,355279,466391,254372,42803,190497,333687,569721,705300,944837,960569,663192,589112,425528,766854,264766,7108) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 342057 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 342057 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]