SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001354s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445176 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445176 [ RunTime:0.001600s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (999528,730163,311518,327058,6928,37404,104404,625936,479801,714378,88251,110310,472482,4609,941464,381720,991552,108195,446139,634082,202722,622948,316429,499223,658854,259475,1022817,411207,737289,495681,931894,344649,90515,999082,82946,169776,531198,599173,719864,389737,1000718,43277,427052,14524,599725,629677,59668,7108,924425,887353,6298,65121,652803,514424,889148,716123,317270,641718,799300,572604) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445176 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445176 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000828s ]