SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019493 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019493 [ RunTime:0.001632s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (879958,149003,348858,575701,1040556,19596,222280,425790,744387,730458,986119,376229,853187,19637,337006,153571,47219,634534,278333,975674,725668,449531,432326,582663,270890,473158,476645,698196,914170,113369,263837,338313,101320,1008260,361083,805538,674713,614564,346750,362980,535865,46576,735971,166948,804470,918938,723900,961499,534626,178621,905945,733793,249172,289957,416155,250231,685075,991121,8385,186341) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019493 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019493 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]