SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014924 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014924 [ RunTime:0.001482s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (323534,837947,321565,279677,310688,1018618,380543,751872,839709,712444,741751,277924,495352,393580,656388,164876,786314,964749,674805,864012,829821,811900,733001,685530,750656,573477,17241,859260,571364,996215,665374,889209,898664,467514,254151,1010485,436969,715536,618457,337422,381725,943708,337480,852816,856304,266475,859304,56539,785242,477406,276518,870241,20660,665686,284519,811671,374990,318553,513015,283780) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002635s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014924 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014924 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001384s ]