SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 464583 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 464583 [ RunTime:0.001823s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (864919,135828,151215,142112,819781,809511,294528,841158,544909,697,405228,369121,306903,121725,871237,530968,65589,390476,674961,1026790,638832,92023,601784,164325,198738,833363,422237,596292,970138,120032,559543,338355,249521,850821,710396,240984,939276,811977,211985,610863,111654,121912,371305,93248,978878,647054,849342,711410,389463,772396,1045438,337497,907306,831441,850981,524335,711406,287103,123987,726295) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000936s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 464583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 464583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]