SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 274437 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 274437 [ RunTime:0.001413s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (454860,251289,604623,109307,237588,111398,121880,17700,130854,513952,357823,571230,96260,672191,805504,244427,74920,1005111,459979,387015,717666,853512,800141,184013,855950,474276,871658,105437,449931,358321,617266,383505,9402,195881,135523,912632,894474,1026492,105532,235272,735417,93856,754256,119206,566250,801670,533910,351391,485403,34233,588153,895496,146327,134242,291965,818088,908969,725763,1028981,147789) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 274437 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 274437 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]