SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001377s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005243 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005243 [ RunTime:0.002157s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (270129,655485,147,573677,191585,868802,1028878,664564,507705,898106,578721,516590,401455,330005,532877,783448,703285,996263,245502,469817,301021,757826,426211,841031,235245,381927,1033330,239084,728883,202362,771677,160394,923253,129051,104238,638653,585925,241424,422240,822249,512158,244183,590214,769327,329926,527031,771668,37544,995881,691821,480460,905707,914093,877383,609595,349498,428183,623481,912948,107830) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000388s ]