SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001349s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020116 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020116 [ RunTime:0.001752s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (927287,758621,729139,280350,656120,548425,51194,540885,518988,25259,1017134,337339,848006,997885,1020366,3875,944486,801943,864359,884699,37178,668675,641052,872025,496240,409483,924650,33071,823860,61840,140710,106795,440996,748198,795173,835198,700978,1026204,1022967,750987,19380,1004386,412052,928374,1022169,699863,153446,873171,488684,157669,987752,371809,140999,190070,195611,653759,72531,248103,813736,245671) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000955s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020116 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020116 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]