SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520088 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520088 [ RunTime:0.003321s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1047675,139725,841382,807082,1007324,430828,490075,758820,295046,106304,951132,923330,261488,913966,144565,880304,936307,668718,1045842,695281,343793,793760,537852,605309,556885,78463,194287,942947,226573,810823,49010,1046192,1041389,161040,78478,146285,285804,392034,131320,845036,843289,789897,84812,946874,943132,845767,981558,34053,440320,148727,237070,734211,1043682,682792,894048,338536,542759,903770,81825,635287) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520088 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520088 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001937s ]