SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014382 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014382 [ RunTime:0.004199s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (369481,274951,183721,748759,698637,127825,279525,267683,714356,839432,943600,444394,584421,921482,1007685,381396,13528,719652,744128,263673,1040724,317682,215889,207090,563638,798411,821192,367859,872804,794741,157599,763934,439028,275946,242326,888569,786783,929008,280582,975545,417478,435575,618293,256423,615407,307719,383191,811985,194114,227461,890512,181230,161406,546173,377690,105583,254372,656618,282316,801082) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014382 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014382 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]