SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311698 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311698 [ RunTime:0.001632s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (345230,31203,774645,209259,651278,21460,1010281,191445,111491,123905,480601,27069,817808,803673,285600,938586,177474,356498,701933,712336,950433,1028746,64082,806041,808252,1014490,150950,1019807,576231,549827,980580,400735,591735,461395,455640,312264,186247,379069,309497,999333,843250,740651,775564,741612,884810,775557,226048,579573,68963,176379,842487,177489,584675,69048,784399,368918,306347,800494,139052,61120) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004936s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311698 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311698 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]