SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019713 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019713 [ RunTime:0.002428s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (468702,615070,256242,988609,369649,327140,229049,7870,657589,963005,9549,189052,586102,268795,648163,115681,683184,863127,271082,675495,983657,149175,181350,499193,231381,281508,106998,49380,307374,920790,738958,43779,1005836,685043,1005420,875701,969924,457607,953600,205771,578491,732027,87533,848237,784298,800638,224740,990379,204509,620476,141174,970426,616062,888199,506611,254543,41703,375117,615530,132570) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]