SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002667 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002667 [ RunTime:0.001764s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (408436,568303,131686,549168,448909,914524,494411,1002040,350951,73690,79736,654547,352456,307037,230834,1001545,579783,1034632,699462,1040126,296057,271561,460355,903010,496842,718613,221298,151002,707629,115768,180438,564089,74430,449624,605912,392498,455560,329200,20644,981076,955156,786131,218743,782189,370352,987807,623389,577464,813945,474281,443634,105652,900117,232331,860859,267080,480485,215639,137935,605723) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002667 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002667 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]