SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407439 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407439 [ RunTime:0.001905s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (18108,480763,864099,140452,84732,468434,968072,789926,846355,579164,137897,804587,715337,53103,1041377,47952,415143,470408,241269,930142,981031,741811,488542,259290,554289,327429,212776,519204,894773,562576,447521,1009073,404306,145830,21462,919818,907005,467946,459222,249482,45895,9603,601670,845436,749277,135023,859288,322410,165626,85728,1012925,136902,13207,347348,287695,765272,438094,415189,289449,109198) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407439 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407439 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000429s ]