SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413609 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413609 [ RunTime:0.001778s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (585687,888993,835547,357072,369183,617723,518840,254671,911096,153631,577500,834031,529783,312524,790764,1013313,688983,186617,729950,291996,198798,647844,681805,839353,605267,423072,282725,229480,806013,405910,526351,342130,600313,1022051,673256,321175,577876,1032261,180112,941106,760942,235105,19574,20986,899313,696989,281033,68188,244717,985391,851505,619508,971161,265668,669033,1022227,287306,875554,825370,335736) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413609 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413609 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000662s ]