SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001595s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 171036 LIMIT 1 [ RunTime:0.000679s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 171036 [ RunTime:0.002712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (409214,1027852,147348,241158,1009812,611158,429919,691617,41468,504335,975727,519262,1008337,625962,709848,818147,753652,566310,121707,690991,502405,754775,430343,199522,179214,467283,854198,303792,587233,99797,521353,185758,521870,955814,662802,927626,577126,132416,962654,639605,119052,105572,658533,690171,775412,180970,263008,1043136,920716,366451,640179,1019320,465177,527171,557931,607196,709679,324021,19397,633433) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001622s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 171036 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000593s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 171036 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001554s ]