SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001933s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 568018 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 568018 [ RunTime:0.003784s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (459693,21670,449380,815722,692694,597910,701909,914279,838227,222585,647822,148900,849560,215870,374140,20440,272505,1031751,913727,21356,451656,952184,506449,936671,44651,763399,801638,173665,134991,459915,622133,857795,324289,589499,282680,402537,502462,235072,146104,395634,3856,234221,65107,757400,293022,959737,730667,470069,327752,56174,273738,544130,859624,292570,754737,899265,658798,428926,1034521,438456) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 568018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 568018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]