SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 856995 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 856995 [ RunTime:0.001657s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (386982,573405,778973,199820,484192,451962,796667,393235,693421,755607,534301,741106,94587,355441,710369,223694,737272,849946,305143,182265,1031993,293993,42777,216297,369074,978981,130210,458006,309538,220074,701461,233198,355245,572767,822764,125059,215545,718944,463287,739321,93996,66189,188642,481156,961502,214104,719931,722106,994679,802055,435478,587830,199957,991651,937500,68689,547534,894324,309821,3658) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 856995 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 856995 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]