SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 807187 LIMIT 1 [ RunTime:0.000521s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 807187 [ RunTime:0.001772s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1009683,764112,718009,574168,293543,771583,919249,648365,425917,835122,397844,604291,631372,857613,296588,899227,42245,140779,604416,182510,801230,183466,703713,635882,414672,679326,567135,303547,198132,175913,689668,661943,553066,427849,863045,822068,572900,769020,360543,34908,343902,498756,200662,247647,924808,346050,136766,665926,807452,191265,438051,673309,72017,830183,6014,999950,744337,893184,420253,207286) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 807187 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 807187 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]