SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 555445 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 555445 [ RunTime:0.001751s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (621649,243265,109103,918974,886498,191177,191467,740568,928794,1557,712095,282804,383645,22948,414554,808858,658388,776836,724061,868537,383790,357440,254697,949187,746284,669731,795020,547292,496469,626146,792987,626192,997854,762592,1002774,846263,302076,639874,444344,535296,418666,25128,577143,433726,118204,435010,995262,217910,237004,250471,695573,573222,762572,130734,729570,1012835,589678,737834,710524,87752) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000908s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 555445 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 555445 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]