SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341210 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341210 [ RunTime:0.001664s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (435287,592433,868142,144225,760411,388778,357554,30686,970238,226795,145812,97368,882138,333663,402948,438018,751977,578345,456106,737935,368471,203461,427265,460809,946699,347136,568716,498754,845524,720833,416229,161246,1013637,973597,1005209,869101,293179,719872,396900,1030716,421723,841980,548496,775688,118957,565939,564914,465760,123260,592755,1003217,756613,301387,907590,154665,202842,786160,255870,1043385,651952) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000520s ]