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` = 514523 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514523 [ RunTime:0.002019s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (27399,41445,154569,412365,583834,499157,72805,16041,915777,129232,1039793,1035111,265129,969084,485965,114030,369734,1040351,811741,857876,140359,770742,973657,135561,185529,884633,327429,511863,853405,779636,567601,734664,707318,362681,572730,491994,852411,615252,392807,400333,577328,904392,867090,898117,411265,526748,682142,942314,799486,83514,268711,874375,734953,200977,903830,565089,346961,468518,383679,378804) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514523 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514523 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]