SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319553 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319553 [ RunTime:0.002012s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (880451,839403,374600,672974,97370,803890,795613,498501,735569,670276,40325,504076,819657,802057,708787,958275,629108,313541,919356,848198,825665,785231,421945,254843,617772,44077,371268,996406,680297,806318,717597,593982,770733,495003,961915,508246,698972,29010,384370,884650,305612,271834,417119,292232,863159,928881,623670,252694,107616,552241,628333,597463,212463,463199,199380,376569,560396,435356,243324,684489) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319553 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319553 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]